Data preparation

We gathered data from the ENTSOE Transparency Platform in order to show the current situation of the European Electricity Market (find the term) and show how the perspectives in 2030 could change the trade between european countries and the problem of grid stability.

Step1: Current situation of the energy market for three main European countries:

Step2: show the objective of countries in terms of production by 2030

Coin a term: % of overloading (area)

Step3: show how trade could explode by then And highlight the role of HVDC in this (not overload local networks, speed up transmission between far away zones)

Step4: show some scenarios with financial analysis How to cope with that situation ?

ID Box * Check correlation between Solar Gen and Negative net needs on daylight hours vs. other generation sources

Step 1: Current situation of the energy market for three main European countries

Load analysis

## `summarise()` has grouped output by 'country', 'season'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'country'. You can override using the `.groups` argument.
Analysis of peaks per country and season / NEEDS FORMATTING TO BE READ
Country Season Peak to valley ratio Median peak hour Median valley hour
France 1 1.276295 19 5
France 2 1.372889 13 5
France 3 1.431593 13 5
France 4 1.329106 19 5
Germany 1 1.424979 19 4
Germany 2 1.492738 13 4
Germany 3 1.515042 13 4
Germany 4 1.464275 18 3
Spain 1 1.500286 21 5
Spain 2 1.419711 14 5
Spain 3 1.444240 14 5
Spain 4 1.486108 21 5
Highest Daily loads (average) / TO BE COMPARED LATER WITH PRODUCTION PEAKS
country avg_highest_peak
France 88456.20
Germany 78032.35
Spain 39860.05

Generation analysis

Figure 1 - Hourly electricity generation per country and season

This graph tends to show that peak generations are more intense for Germany than for France, especially in spring and summer (effect of solar energy production)

In figures, let’s check: - % of production different than load - cumulated absolute(net need)/generation - % of hours when production is more than 120% of the load

Overall generation analysis (TO BE DONE) - CHECK SUM OF GENERATIONS

Graph with legend “This graph tends to show that we have the following generations per year (TWh) for France, Germany and Spain.”

Per energy source generation analysis

The idea is to show what kind of energy is produced where. This is the baseline that will be used to generate production profiles for 2030.

Figure 2 - Hourly generation per generation type

## `summarise()` has grouped output by 'country'. You can override using the `.groups` argument.

Figure 3 - Net trade need ratio shows current depedency to trade and storage

Net Trade Need Ratio analysis shows what countries depend most on trade and storage to balance their system load.Further analysis shows (TO BE DONE) that France is a not exporter especially during winter and autumn while Germany is during spring and summer.